Real-time workflow audit data integration into data warehouse systems
نویسندگان
چکیده
Workflow management systems are being increasingly used by many organizations to automate business processes and decrease costs. Audit trails from workflow management systems include significant amounts of information that can be used to analyze and monitor the performance of business processes in order to improve the efficiency. Traditional approaches for using workflow audit trail for decision support purposes are lacking in transforming the workflow audit trail in real-time to valuable business information. In this paper, we introduce a data warehousing approach for extracting, transforming, and evaluating workflow audit trail data with the aim of providing a solid data foundation for process-oriented decision support. We introduce an architecture that allows the propagation and transformation of audit data from workflow management systems in near real-time to a data warehouse system. The architecture takes full advantage of existing J2EE (Java 2 Platform, Enterprise Edition) technology and uses an ETL container for providing a scalable, near real-time ETL environment for workflow audit trails.
منابع مشابه
Data Warehouse Model for Audit Trail Analysis in Workflows
Business process performance evaluation is a key step towards assessing and improving e-business operations. In real-scale scenarios, such evaluation requires the collection, aggregation and processing of vast amounts of data, in particular audit trails. This paper aims at enabling such evaluation by integrating workflow technology with data warehousing. We first present a data model for captur...
متن کاملProcess-driven Management Information Systems - Combining Data Warehouse and Workflow Technology
The use of workflow technology promises efficiency gains through the automation of manual routing, coordination and work distribution tasks. During the execution of workflows, state-changes of the workflow engine are recorded in a log file or database, the so-called audit trail. Combined with business object data, the audit trail provides exact and timely information about the operational behav...
متن کاملManaging Continuous Data Integration Flows
Understanding the performance and dynamic behavior of workflow is crucial in being able to modify, maintain, and improve it. A particularly difficult aspect of measuring the performance of workflows is the dissemination of event data and its transformation into business metrics. In this paper we introduce an architecture that supports a continuous integration of event data from various source s...
متن کاملImprovement of the Analytical Queries Response Time in Real-Time Data Warehouse using Materialized Views Concatenation
A real-time data warehouse is a collection of recent and hierarchical data that is used for managers’ decision-making by creating online analytical queries. The volume of data collected from data sources and entered into the real-time data warehouse is constantly increasing. Moreover, as the volume of input data to the real time data warehouse increases, the interference between online loading ...
متن کاملWorkflow-based Process Controlling
The exact and timely analysis of automated business processes through the analysis of protocol data is one factor for the use of workflow management systems in organizations. While in the past the automated routing and distribution of work have been prevailing factors in the marketing of workflow applications, the side-effect of having actual and precise business data for analysis yields many o...
متن کامل